package com.ling.pl.autoproject.definition.logic.model;

import com.ling.pl.core.commons.annotation.Dict;
import com.ling.pl.core.commons.annotation.ModelProperty;

import javax.persistence.Column;

public class DataQuerySqlParamProperty {
    @Column(name = "QUERY_ID", length = 36)
    @ModelProperty(comment = "查询id")
    String queryId;

    @Column(name = "COMBINATION_ID", length = 36)
    @ModelProperty(comment = "查询id")
    String combinationId;

    @Column(name = "NAME", length = 150)
    @ModelProperty(comment = "名称")
    String name;

    @Column(name = "QUERY_TYPE", length = 150)
    @ModelProperty(comment = "连接方式")
    @Dict(code = "builder.entity.queryType", des = "属性条件,组条件,自定义")
    String queryType;

    @Column(name = "PROPERTY", length = 150)
    @ModelProperty(comment = "实体属性")
    String property;

    @Column(name = "PROPERTY_PROCESSOR", length = 150)
    @ModelProperty(comment = "值处理")
    String propertyProcessor;

    @Column(name = "QUERY_OPERATION", length = 150)
    @ModelProperty(comment = "符号操作")
    @Dict(code = "builder.entity.queryOperation", des = "=,<>,>,>=,<,<-.null, not null, is null,%,%...,...#,in, not in")
    String queryOperation;

    @Column(name = "PARAM_VALUE_TYPE", length = 150)
    @ModelProperty(comment = "变量类型")
    @Dict(code = "builder.entity.paramValueType", des = "用户上下文,全局上下文,数据上下文,系统上下文,网页请求上下文")
    String paramValueType;

    @Column(name = "PARAM", length = 150)
    @ModelProperty(comment = "条件值")
    String param;

    @Column(name = "DES", length = 150)
    @ModelProperty(comment = "说明")
    String des;

    @Column(name = "IS_NULL_IGNORE")
    @ModelProperty(comment = "无值时忽略")
    Boolean isNullIgnore;

    @Column(name = "REMARK", length = 150)
    @ModelProperty(comment = "备注")
    String remark;
}
